CREATE PROCEDURE InsertCategoryLog 
    @CategoryID INT, 
    @LogID INT 
AS 
BEGIN 
    SET NOCOUNT ON;

    DECLARE @CatLogID INT 
    SELECT @CatLogID FROM CategoryLog WHERE CategoryID=@CategoryID and LogID = @LogID 
    IF @CatLogID IS NULL 
    BEGIN 
        INSERT INTO CategoryLog (CategoryID, LogID) VALUES(@CategoryID, @LogID) 
        RETURN @@IDENTITY 
    END 
    ELSE RETURN @CatLogID 
END